﻿CREATE PROCEDURE [dbo].[League_Members_SelectByLeagueIdTournamentName]
   @league_id uniqueidentifier,
   @tournament_name nvarchar (40)
AS
  SELECT [dbo].[League_Members].[league_id],
         [dbo].[League_Members].[bowler_id]
    FROM [dbo].[League_Members]
         INNER JOIN [dbo].[Tournament_Members]
                    ON [dbo].[League_Members].[league_id] = [dbo].[Tournament_Members].[league_id]
                       AND [dbo].[League_Members].[bowler_id] = [dbo].[Tournament_Members].[bowler_id]
   WHERE [dbo].[Tournament_Members].[league_id] = @league_id
         AND [dbo].[Tournament_Members].[tournament_name] = @tournament_name


